/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50622
 Source Host           : localhost
 Source Database       : sqladmin

 Target Server Type    : MySQL
 Target Server Version : 50622
 File Encoding         : utf-8

 Date: 03/15/2015 20:57:30 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `project`
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `project_name` varchar(64) NOT NULL,
  `project_desc` varchar(128) DEFAULT NULL,
  `gmt_create` datetime NOT NULL,
  `is_deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `project`
-- ----------------------------
BEGIN;
INSERT INTO `project` VALUES ('1', 'agc', '测试项目', '2015-03-15 14:06:22', '0');
COMMIT;

-- ----------------------------
--  Table structure for `project_table`
-- ----------------------------
DROP TABLE IF EXISTS `project_table`;
CREATE TABLE `project_table` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `project_id` bigint(20) NOT NULL,
  `table_name` varchar(128) NOT NULL,
  `gmt_create` datetime NOT NULL,
  `table_desc` varchar(128) DEFAULT NULL,
  `is_deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `project_table`
-- ----------------------------
BEGIN;
INSERT INTO `project_table` VALUES ('1', '1', 'table_12', '2015-03-15 18:40:20', '表12', '0');
COMMIT;

-- ----------------------------
--  Table structure for `table_field`
-- ----------------------------
DROP TABLE IF EXISTS `table_field`;
CREATE TABLE `table_field` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `table_id` bigint(20) NOT NULL,
  `field_name` varchar(64) NOT NULL,
  `field_type` varchar(64) NOT NULL,
  `not_null` int(11) NOT NULL,
  `field_desc` varchar(256) DEFAULT NULL,
  `default_value` varchar(64) DEFAULT NULL,
  `gmt_create` datetime NOT NULL,
  `field_length` int(11) DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  `is_key` tinyint(4) DEFAULT NULL,
  `is_auto_incre` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
